﻿<?xml version="1.0" encoding="utf-8" ?>
<tableDefinitions xmlns="http://schemas.microsoft.com/wix/2006/tables">
  <tableDefinition name="DatabaseConnectionString">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="ConnectionString" type="string" length="0" modularize="property" category="formatted" />
  </tableDefinition>
  <tableDefinition name="MSSQLDatabase">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="ComponentId" type="string" length="72" modularize="column" category="identifier" nullable="yes" />
    <columnDefinition name="Name" type="string" length="255" category="formatted" />
    <columnDefinition name="Collate" type="string" length="32" nullable="yes" category="formatted" />
    <columnDefinition name="Purpose" type="string" length="32" category="formatted" nullable="yes" />
    <columnDefinition name="ConnectionStringId" type="string" length="72" modularize="column" nullable="no" keyTable="DatabaseConnectionString" keyColumn="1" category="identifier" />
    <columnDefinition name="Attributes" type="number" length="2" nullable="yes" minValue="0" maxValue="127" description="1 == create on install, 2 == drop on uninstall, 8 == drop on install, 16 == create on uninstall, 32 == check if exists"/>
  </tableDefinition>
  <tableDefinition name="MSSQLDatabaseOption">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="MSSQLDatabaseId" type="string" length="72" modularize="column" nullable="no" keyTable="MSSQLDatabase" keyColumn="1" category="identifier" />
    <columnDefinition name="Value" type="string" length="255" category="formatted" />
  </tableDefinition>
  <tableDefinition name="MSSQLDatabaseFileSpec">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="MSSQLDatabaseId" type="string" length="72" modularize="column" nullable="no" keyTable="MSSQLDatabase" keyColumn="1" category="identifier" />
    <columnDefinition name="Name" type="string" length="255" category="formatted" />
    <columnDefinition name="Filename" type="string" length="255" category="formatted" nullable="no" />
    <columnDefinition name="Type" type="string" length="255" category="formatted" nullable="yes" />
    <columnDefinition name="Size" type="string" length="255" category="formatted" nullable="yes" />
    <columnDefinition name="MaxSize" type="string" length="255" category="formatted" nullable="yes" />
    <columnDefinition name="GrowthSize" type="string" length="255" category="formatted" nullable="yes" />
  </tableDefinition>
  <tableDefinition name="MSSQLDataFile">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="ComponentId" type="string" length="72" modularize="column" category="identifier" nullable="yes" />
    <columnDefinition name="ConnectionStringId" type="string" length="72" modularize="column" nullable="no" keyTable="DatabaseConnectionString" keyColumn="1" category="identifier" />
    <columnDefinition name="Database" type="string" length="72" modularize="column" category="formatted" nullable="yes" />
    <columnDefinition name="Schema" type="string" length="255" category="formatted" nullable="yes" />
    <columnDefinition name="Table" type="string" length="255" category="formatted" nullable="no" />
    <columnDefinition name="Filename" type="string" length="255" category="formatted" nullable="yes" />
    <columnDefinition name="BinaryId" type="string" category="identifier" nullable="yes" length="72" modularize="column" keyTable="Binary" keyColumn="1" />
    <columnDefinition name="Condition" type="string" length="0" modularize="property" nullable="yes" category="formatted" />
    <columnDefinition name="Attributes" type="number" length="2" nullable="yes" minValue="0" maxValue="127" />
  </tableDefinition>
  <tableDefinition name="MSSQLDataFileParameter">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="MSSQLDataFileId" type="string" length="72" modularize="column" nullable="no" keyTable="MSSQLDataFile" keyColumn="1" category="identifier" />
    <columnDefinition name="Value" type="string" length="255" category="formatted" />
  </tableDefinition>
  <tableDefinition name="AccessDatabase">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="ComponentId" type="string" length="72" modularize="column" category="identifier" nullable="yes" />
    <columnDefinition name="DBQ" type="string" length="255" category="formatted" />
    <columnDefinition name="ConnectionStringId" type="string" length="72" modularize="column" nullable="no" keyTable="DatabaseConnectionString" keyColumn="1" category="identifier" />
    <columnDefinition name="Attributes" type="number" length="2" nullable="yes" minValue="0" maxValue="127" description="1 == create on install, 2 == drop on uninstall, 8 == drop on install, 16 == create on uninstall, 32 == check if exists"/>
  </tableDefinition>
  <tableDefinition name="ODBCExecute">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="ComponentId" type="string" length="72" modularize="column" category="identifier" nullable="yes" />
    <columnDefinition name="ConnectionStringId" type="string" length="72" modularize="column" nullable="no" keyTable="DatabaseConnectionString" keyColumn="1" category="identifier" />
    <columnDefinition name="Sql" type="string" category="formatted" nullable="yes" length="0" />
    <columnDefinition name="Filename" type="string" category="formatted" nullable="yes" length="255" modularize="column" />
    <columnDefinition name="OutputFilename" type="string" category="formatted" nullable="yes" length="255" modularize="column" />
    <columnDefinition name="XsltFilename" type="string" category="formatted" nullable="yes" length="255" modularize="column" />
    <columnDefinition name="BinaryId" type="string" category="identifier" nullable="yes" length="72" modularize="column" keyTable="Binary" keyColumn="1" />
    <columnDefinition name="Condition" type="string" length="0" modularize="property" nullable="yes" category="formatted" />
    <columnDefinition name="Delimiter" type="string" length="0" modularize="column" nullable="yes" category="formatted" />
    <columnDefinition name="Type" type="string" length="15" modularize="column" nullable="yes" category="formatted" />
    <columnDefinition name="BasePath" type="string" length="255" modularize="column" nullable="yes" category="formatted" />
    <columnDefinition name="Attributes" type="number" length="2" nullable="yes" minValue="0" maxValue="127" description="1 == execute on install, 2 == execute on uninstall (, 4 = execute on reinstall)"/>
  </tableDefinition>
  <tableDefinition name="ODBCDataSourceConfig">
    <columnDefinition name="Id" type="string" length="72" primaryKey="yes" modularize="column" category="identifier" />
    <columnDefinition name="ComponentId" type="string" length="72" modularize="column" category="identifier" nullable="yes" />
    <columnDefinition name="Driver" type="string" category="formatted" nullable="yes" length="255" modularize="column" />
    <columnDefinition name="Name" type="string" category="formatted" nullable="yes" length="255" modularize="column" />
    <columnDefinition name="Value" type="string" category="formatted" nullable="yes" length="0" />
    <columnDefinition name="Type" type="string" category="formatted" nullable="yes" length="12" modularize="column" />
    <columnDefinition name="Condition" type="string" length="0" modularize="property" nullable="yes" category="formatted" />
    <columnDefinition name="Attributes" type="number" length="2" nullable="yes" minValue="0" maxValue="127" />
  </tableDefinition>
</tableDefinitions>
